Computer Science for IGCSE & O level - Databases (Section 2 - No. 27)
What is the role of a database transaction?
To combine multiple queries into a single operation, ensuring atomicity and consistency.
To create a database backup.
To optimize database performance.
To automatically generate reports.
Paliwanag
A database transaction groups multiple operations together, treating them as a single unit of work, guaranteeing data integrity through ACID properties.